create table qrtz_simprop_triggers
(
    sched_name    nvarchar(120) not null,
    trigger_name  nvarchar(200) not null,
    trigger_group nvarchar(200) not null,
    str_prop_1    nvarchar(512),
    str_prop_2    nvarchar(512),
    str_prop_3    nvarchar(512),
    int_prop_1    int,
    int_prop_2    int,
    long_prop_1   bigint,
    long_prop_2   bigint,
    dec_prop_1    decimal(13, 4),
    dec_prop_2    decimal(13, 4),
    bool_prop_1   nvarchar,
    bool_prop_2   nvarchar,
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_simprop_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers
)
go

exec sp_addextendedproperty 'MS_Description', '同步机制的行锁表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simprop_triggers'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simprop_triggers', 'COLUMN',
     'sched_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_name的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'trigger_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_group的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'trigger_group'
go

exec sp_addextendedproperty 'MS_Description', 'String类型的trigger的第一个参数', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'str_prop_1'
go

exec sp_addextendedproperty 'MS_Description', 'String类型的trigger的第二个参数', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'str_prop_2'
go

exec sp_addextendedproperty 'MS_Description', 'String类型的trigger的第三个参数', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'str_prop_3'
go

exec sp_addextendedproperty 'MS_Description', 'int类型的trigger的第一个参数', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simprop_triggers',
     'COLUMN', 'int_prop_1'
go

exec sp_addextendedproperty 'MS_Description', 'int类型的trigger的第二个参数', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simprop_triggers',
     'COLUMN', 'int_prop_2'
go

exec sp_addextendedproperty 'MS_Description', 'long类型的trigger的第一个参数', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simprop_triggers',
     'COLUMN', 'long_prop_1'
go

exec sp_addextendedproperty 'MS_Description', 'long类型的trigger的第二个参数', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_simprop_triggers',
     'COLUMN', 'long_prop_2'
go

exec sp_addextendedproperty 'MS_Description', 'decimal类型的trigger的第一个参数', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'dec_prop_1'
go

exec sp_addextendedproperty 'MS_Description', 'decimal类型的trigger的第二个参数', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'dec_prop_2'
go

exec sp_addextendedproperty 'MS_Description', 'Boolean类型的trigger的第一个参数', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'bool_prop_1'
go

exec sp_addextendedproperty 'MS_Description', 'Boolean类型的trigger的第二个参数', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_simprop_triggers', 'COLUMN', 'bool_prop_2'
go

